West follow: the original article is from the exposure of database hackers-Database Server Protection Technology. If you really want to study database security, you can buy one to see if it supports genuine versions. This article is from Chapter
Sybase configuration Parameters sp_configure ' max online engines ', 4
Go
--Configure the number of boot CPUs
sp_configure ' number of engines at startup ', 4
Go
--Configure Maximum memory count
sp_configure ' max memory ', 2097151
Go
--Allocating
A brief introduction to Sybase database
Sybase Company was founded in 1984, the company name "Sybase" from "System" and "database" combined meaning. Sybase's first relational database product was the Sybase SQLServer1.0, which was launched in May 19
Connect a VC to the Sybase DatabaseFirst, you must install the Sybase client and configure the Sybase client. After the installation is complete, run dsedit in the program for configuration.Server is the name of the database to be accessed, as well
Abstr]
"Sybase database does not support subqueries, so ......", We often hear this in database development. Is Sybase really true? Let's go to the sybase database to see which subquery statements are supported and not supported respectively. Hope
sp_configure ' max online engines ', 4Go--Configure the number of boot CPUssp_configure ' number of engines at startup ', 4Go--Configure Maximum memory countsp_configure ' max memory ', 2097151Go--Allocating maximum stored procedure
Character numeric type:
Char, varchar, long varchar
Nchar, nvarchar, long nvarchar
-Compatible data types are implemented through domains: sysname (varchar (30), text (long varchar domain), ntext (long nvarchar domain), and XML (long
1, consider the data planning, storage space and so on. estimated by formula;
character set, sort, page size cannot be changed after creation. data storage planning, especially for cluster mode deploymentLUN Plan Essentials. the disk used by IQ
Functions are not supported in versions earlier than sybase12.5, but sometimes we need some functions, not just processes. Java can be used here, in addition, writing Java is certainly much better than writing a stored procedure. the ability or type
Performance case 02 -- sybase connection blocking, 02 sybase
Symptom:Recently, a problem was reported on the site. during the approval process, the system often gets stuck. The whole system is useless and the browser access is in the loading state.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.